
<?php

include ($_SERVER['DOCUMENT_ROOT'].'/config/connect.php');

?>

<head>
<link rel="stylesheet" type="text/css" href="../../layout/mystyle.css">
</head>

<SPAN CLASS="text_h1">Evenementen per vereniging</SPAN>
<BR>
<BR>
<?php
$result = mysql_query("SELECT vereniging.naam, Count(vereniging.verenigingid)
FROM vereniging
LEFT JOIN evenement
ON vereniging.verenigingid=evenement.organiserende_verenigingsid; 

");
if (mysql_error()) die (mysql_error ()); 
echo '<table class="rapporttable">
<TR>       
<th>Vereniging:</th>        
<th>Aantal evenementen:</th>
</TR>';   
               while ($row = mysql_fetch_array($result)) {
print('<TR>');
print('<td>' . $row ['naam'] . '</td>');
print('<td>' . $row ['Count(vereniging.verenigingid)'] . '</td>');     
 }
  ?>
</TR>
</table>



